USE [MainDB]
GO

/****** Object:  StoredProcedure [dbo].[InsertIssuesValuesNEW]    Script Date: 10/21/2014 09:09:54 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


-- =============================================
-- Author:		<Author,,Aniruddha>
-- Create date: <Create Date,,20 October>
-- Description:	<Description,, To insert the values >
-- =============================================
ALTER PROCEDURE [dbo].[InsertIssuesValuesNEW]

@d_date    nvarchar(max),
@truck_no    nvarchar(max),
@no_bags    nvarchar(max),
@dispatched_gr_wt    nvarchar(max),
@Grade    nvarchar(max),
@LRNo    nvarchar(max),
@NAME_TRANSPORTER    nvarchar(max),
@DESTINATION    nvarchar(max),
@value    nvarchar(max),
@stack_no    nvarchar(max),
@ORIGINATING_HUB    nvarchar(max),
@STA_NO    nvarchar(max),
@REMARKS    nvarchar(max)

AS
BEGIN
	-- Insert statements for procedure here
	INSERT INTO IssueNEW
	 (d_date,
truck_no,
no_bags,
dispatched_gr_wt,
Grade,
LRNo,
NAME_TRANSPORTER,
DESTINATION,
value,
stack_no,
ORIGINATING_HUB,
STA_NO,
REMARKS

)
	Values (
@d_date,
@truck_no,
@no_bags,
@dispatched_gr_wt,
@Grade,
@LRNo,
@NAME_TRANSPORTER,
@DESTINATION,
@value,
@stack_no,
@ORIGINATING_HUB,
@STA_NO,
@REMARKS
) 
END


GO


